package com.kangyi.app.mapper;

import com.kangyi.vo.FeeVO;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Select;

import java.math.BigDecimal;
import java.util.List;

/**
 * @author Blank
 * @version 1.0
 */
@Mapper
public interface FeeMapper {

    @Select("select price from fee where nursing_home_id = #{id} and type = 1 ORDER BY price ASC LIMIT 1;")
    BigDecimal getFee(Integer id);

    @Select("SELECT * FROM fee WHERE nursing_home_id = #{id}")
    List<FeeVO> inquiryNursingHomeFees(Integer id);
}
